{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Reference Range Verification","Reference Range Establishment"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 03-Aug-2023. Last reviewed on 03-Aug-2023.\r\nVAL 2004 (version 1.1). Reference Range Pack. Page 1 of 3"]
["Please refer to VAL2001_ Quantitative Validation Guidelines for more details on reference range requirements."]
[]
["Fill in the method and analyte information in yellow cells."]
[]
["Reference Range Verification-"]
["Fill in the proposed reference range in the top of the form. Enter the results from 20 healthy participants in the yellow cells. The acceptability will be automatically calculated. "]
[]
[]
["Reference Range Establishment- "]
["Enter the results from 120 healthy participants in the yellow cells. The reference range will be automatically calculated at the top of the form. "]

{"sheet":"Reference Range Verification","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,0,3,10],[7,0,7,2],[29,1,29,2],[31,1,31,2],[5,3,5,7],[5,9,5,10],[6,3,6,7],[5,0,5,2],[6,1,6,2]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 03-Aug-2023. Last reviewed on 03-Aug-2023.\r\nVAL 2004 (version 1.1). Reference Range Pack. Page 2 of 3"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",{"$nulls":7},"Date:"]
[null,"Analyte"]
["Proposed Reference Range:",null,null,null,"to",null,null,"Units:"]
[]
[]
[]
[]
[]
[]
[{"$f":"I8","v":0},"Frequency","%"]
[{"$f":"\"<\"&D8","v":"<"},{"$f":"FREQUENCY(F10:J13,G17:G25)","v":0},{"$f":"B16/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"I8","v":0}]
[{"$f":"D8&\"-\"&G18","v":"-0"},0,{"$f":"B17/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8-0.0001","v":-0.0001},{"$f":"F8-D8","v":0}]
[{"$f":"G18&\"-\"&G19","v":"0-0"},0,{"$f":"B18/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.2*H17)","v":0}]
[{"$f":"G19&\"-\"&G20","v":"0-0"},0,{"$f":"B19/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.3*H17)","v":0}]
[{"$f":"G20&\"-\"&G21","v":"0-0"},0,{"$f":"B20/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.4*H17)","v":0}]
[{"$f":"G21&\"-\"&G22","v":"0-0"},0,{"$f":"B21/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.5*H17)","v":0}]
[{"$f":"G22&\"-\"&G23","v":"0-0"},0,{"$f":"B22/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.7*H17)","v":0}]
[{"$f":"G23&\"-\"&G24","v":"0-0"},0,{"$f":"B23/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.8*H17)","v":0}]
[{"$f":"G24&\"-\"&G25","v":"0-0"},0,{"$f":"B24/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"D8+(0.9*H17)","v":0}]
[{"$f":"\">\"&G25","v":">0"},0,{"$f":"B25/COUNT($F$10:$J$13)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"F8","v":0}]
[]
["Mean:  ",{"$f":"AVERAGE(F10:J13)","v":{"$error":"#DIV/0!"}}]
["SD:  ",{"$f":"STDEV(F10:J13)","v":{"$error":"#DIV/0!"}}]
["Median:  ",{"$f":"MEDIAN(F10:J13)","v":{"$error":"#NUM!"}}]
["Range:  ",{"$f":"B34&\"-\"&C34","v":"0-0"}]
["Obs Outside:  ",{"$f":"C16+C25","v":{"$error":"#DIV/0!"}}]
["Grade:  ",{"$f":"IF(C16+C25>0.1,\"Unacceptable\",\"Acceptable\")","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"MIN(F10:J13)","v":0},{"$f":"MAX(F10:J13)","v":0}]

{"sheet":"Reference Range Establishment","index":2,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[43,5,43,6],[7,0,7,2],[28,0,28,1],[2,0,3,10],[5,0,5,2],[5,3,5,7],[5,9,5,10],[6,1,6,2],[6,3,6,7],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[43,2,43,4]]}
["NOTICE: This document is an example only. It must be revised to reflect your lab’s specific processes and/or specific protocol requirements."]
["Approved and current. Effective starting 03-Aug-2023. Last reviewed on 03-Aug-2023.\r\nVAL 2004 (version 1.1). Reference Range Pack. Page 3 of 3"]
["Reference Interval Analysis"]
[]
[]
["Method being evaluated:",{"$nulls":7},"Date:"]
[null,"Analyte"]
["Reference Range:",null,null,{"$f":"IFERROR(K23,\"\")","v":""},"to",{"$f":"IFERROR(J34,\"\")","v":""},null,"Units:"]
[]
[{"$nulls":8},130]
{"$rows_empty":12}
["Mean: ",null,{"$f":"IFERROR(MROUND(AVERAGE(A12:L21),0.01),\"---\")","v":"---"},{"$nulls":5},"Low",null,{"$f":"SMALL(A12:L21,3)","v":{"$error":"#NUM!"}},{"$f":"K23-0.01","v":{"$error":"#NUM!"}}]
["SD: ",null,{"$f":"IFERROR(MROUND(STDEV(A12:L21),0.01),\"---\")","v":"---"},{"$nulls":5},"High",null,{"$f":"SMALL(A12:L21,118)","v":{"$error":"#NUM!"}},{"$f":"K24+0.01","v":{"$error":"#NUM!"}}]
["Minimum: ",null,{"$f":"MIN(A12:L21)","v":0},{"$nulls":5},"Bin1",{"$f":"L23","v":{"$error":"#NUM!"}},{"$f":"K24-K23","v":{"$error":"#NUM!"}}]
["Maximum: ",null,{"$f":"MAX(A12:L21)","v":0},{"$nulls":5},"Bin2",{"$f":"MROUND(J25+(0.2*K25),0.01)","v":{"$error":"#NUM!"}}]
["Median: ",null,{"$f":"IFERROR(MEDIAN(A12:L21),\"---\")","v":"---"},{"$nulls":5},"Bin3",{"$f":"MROUND($J$25+(0.3*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$nulls":8},"Bin4",{"$f":"MROUND($J$25+(0.4*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$f":"I8","v":0},null,"Frequency","Percent",{"$nulls":4},"Bin5",{"$f":"MROUND($J$25+(0.5*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$f":"\"≤\"&\" \"&J25","v":{"$error":"#NUM!"}},null,{"$f":"FREQUENCY(A12:L21,J25:J34)","v":0},{"$f":"C30/120","v":0},{"$nulls":4},"Bin6",{"$f":"MROUND($J$25+(0.6*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$f":"(J25+0.01)&\" \"&\"-\"&\" \"&J26","v":{"$error":"#NUM!"}},null,0,{"$f":"C31/120","v":0},{"$nulls":4},"Bin7",{"$f":"MROUND($J$25+(0.7*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$f":"(J26+0.01)&\" \"&\"-\"&\" \"&J27","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C32/120","v":{"$error":"#N/A"}},{"$nulls":4},"Bin8",{"$f":"MROUND($J$25+(0.8*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$f":"(J27+0.01)&\" \"&\"-\"&\" \"&J28","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C33/120","v":{"$error":"#N/A"}},{"$nulls":4},"Bin9",{"$f":"MROUND($J$25+(0.9*$K$25),0.01)","v":{"$error":"#NUM!"}}]
[{"$f":"(J28+0.01)&\" \"&\"-\"&\" \"&J29","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C34/120","v":{"$error":"#N/A"}},{"$nulls":4},"Bin10",{"$f":"K24","v":{"$error":"#NUM!"}}]
[{"$f":"(J29+0.01)&\" \"&\"-\"&\" \"&J30","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C35/120","v":{"$error":"#N/A"}}]
[{"$f":"(J30+0.01)&\" \"&\"-\"&\" \"&J31","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C36/120","v":{"$error":"#N/A"}},null,null,null,"CI-L",{"$f":"SMALL(A12:L21,1)","v":{"$error":"#NUM!"}},{"$f":"SMALL(A12:L21,7)","v":{"$error":"#NUM!"}}]
[{"$f":"(J31+0.01)&\" \"&\"-\"&\" \"&J32","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C37/120","v":{"$error":"#N/A"}},null,null,null,"CI-U",{"$f":"SMALL(A12:L21,114)","v":{"$error":"#NUM!"}},{"$f":"SMALL(A12:L21,120)","v":{"$error":"#NUM!"}}]
[{"$f":"(J32+0.01)&\" \"&\"-\"&\" \"&J33","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C38/120","v":{"$error":"#N/A"}},null,null,null,"CR",{"$f":"0.5*(J37-I37+J36-I36)/(K24-K23)","v":{"$error":"#NUM!"}}]
[{"$f":"(J33+0.01)&\" \"&\"-\"&\" \"&J34","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C39/120","v":{"$error":"#N/A"}}]
[{"$f":"\">\"&\" \"&J34","v":{"$error":"#NUM!"}},null,{"$error":"#N/A"},{"$f":"C40/120","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,"Confidence Intervals"]
[null,"Lower",{"$f":"I36","v":{"$error":"#NUM!"}},"to",{"$f":"J36","v":{"$error":"#NUM!"}}]
[null,"Upper",{"$f":"I37","v":{"$error":"#NUM!"}},"to",{"$f":"J37","v":{"$error":"#NUM!"}}]